[dbo].[BAEImisNameAddressGetAllForUser]
SQLServer
>
iMIS1521GA
>
Stored Procedures
> dbo.BAEImisNameAddressGetAllForUser
Properties
Parameters
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@Id
varchar(10)
10
SQL Script
create
procedure
[dbo]
.
[BAEImisNameAddressGetAllForUser]
@Id
varchar
(
10
)
as
SELECT
ADDRESS_NUM
FROM
Name_Address
WHERE
ID
=
@Id
GO
Uses
[dbo].[Name_Address]
dbo